Import Expenses Subtask

Use the Import Expenses subtask to import records from an American Express feed. Deltek Time\Expense supports the AMEX KR1025 ASCII file layout for importing expenses.

Location

To display the Import Expenses subtask, complete the following steps:

  1. Click Time & Expense > Expense > Batch Expenses > Batch Expense .
  2. On the Batch Expense screen, click Import Expenses subtask.

Contents

Field Description
File Location Click to select the file you wish to use as your import file.
File Name Click to select the file name.
Bill Currency This field displays the bill currency (currency in which the credit card file is received) of the batch type. Use this information to determine which exchange rate to enter in Exchange Rate to (System Base currency).
Exchange Rate to (System Base currency)

If the pay currency of the expense batch type equals the system's base currency, this field displays a default value of 1.0 and is disabled.

If the pay currency is not the same as the base currency, you can override the default value by entering the exchange rate that should be used when you import the expense amount. This is necessary if the expense was incurred, and should therefore be reimbursed, in a currency other than the system's base currency.

Import Click Import to start the import process.
Import Error Option

From the Import Error option drop-down, choose one of the following:

  • Ignore — Choose this option to ignore errors and proceed with updating the database with those records passing validation.
  • Abort — Choose this option to discontinue the import process if errors occur.